<?php include_once './header.php'; ?>
<?php

include('config.php'); 

echo "<table border=1 >"; 
echo "<tr>"; 
echo "<td><b>IdCotizacion</b></td>"; 
echo "<td><b>IdContactoCot</b></td>"; 
echo "<td><b>IdCursoCot</b></td>"; 
echo "<td><b>SedeCurso</b></td>"; 
echo "<td><b>NumSemanas</b></td>"; 
echo "<td><b>PrecioSemana</b></td>"; 
echo "<td><b>PrecioTotal</b></td>"; 
echo "<td><b>FechaAproximada</b></td>"; 
echo "<td><b>FechaCotiza</b></td>"; 
echo "<td><b>IdTipoAlojamiento</b></td>"; 
echo "<td><b>NombreTipoAlojamiento</b></td>"; 
echo "<td><b>NumeroNoches</b></td>"; 
echo "<td><b>PrecioNoche</b></td>"; 
echo "<td><b>PrecioBusqueda</b></td>"; 
echo "<td><b>PrecioTotalAloja</b></td>"; 
echo "<td><b>PrecioTotalCotizacion</b></td>"; 
echo "</tr>"; 
$result = mysql_query("SELECT * FROM `cotizacion`") or trigger_error(mysql_error()); 
while($row = mysql_fetch_array($result)){ 
foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 
echo "<tr>";  
echo "<td valign='top'>" . nl2br( $row['idCotizacion']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['idContactoCot']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['idCursoCot']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['sedeCurso']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['numSemanas']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['precioSemana']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['precioTotal']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['fechaAproximada']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['fechaCotiza']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['idTipoAlojamiento']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['nombreTipoAlojamiento']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['numeroNoches']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['precioNoche']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['precioBusqueda']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['precioTotalAloja']) . "</td>";  
echo "<td valign='top'>" . nl2br( $row['precioTotalCotizacion']) . "</td>";  
echo "<td valign='top'><a href=editCot.php?idCotizacion={$row['idCotizacion']}>Edit</a></td><td><a href=deleteCot.php?idCotizacion={$row['idCotizacion']}>Delete</a></td> "; 
echo "</tr>"; 
} 
echo "</table>"; 
echo "<a href=newCot.php>New Row</a>"; 

?>


<?php include_once './footer.php'; ?>